1Environment

       OS: Chinese (simple chinese)  Win2K profesional  (SP4)

       mySQL 5.0.15
       myODBC/connecter 3.5.12 
       mySQL Query Browser 1.1.17

       VB6.0 (SP5)
       ADO 2.5 
              ( If other version is used, please change reference to it. 
                To do this:  In the VB IDE,  use menu "Project" --> "References")

2Database import
     I have export the database as file "\DataImport\test.sql". it contain a table "test".
     The table's charset is "gb2312". There are some chinese and japanese charset in it, please restore  it use "uft8" 
     (I use mysql administrator to export. it can't specify charset. I try restore use "uft8", It's ok!)
charset.

3bug replay
      
       I have provide the vb code, please see "\VB Test Code" floder.
 
       before run the code a ODBC, named mysqltest, must setup to connect the database first! 
       (see "\ODBC\ODBC seting.txt")

       Now we can replay the bug:       
       Run the VB Code. Click "Read"  button,  only english char show correct! chinese and japanese show as "?"! the record can't be updated!

        note: the ADO2.5 is used!  other version have the same problem.
        
        I have test the database table with Java use java conector. when specify the charset,  It work!   (myODBC can't specify the charset!).  MySql Query Browser show the correct result too!

        I have have change the Table's charset to "uft8", it show the same!  
        
        Only a table's charset is "latin1", this VB code can show the correct chinese and japanese! But show wrong in MySql Query Browser ! Java program read the wrong result too!

         I think it is myODBC driver can't deal with unicode!
      


thinks!    
by weiKuangLuo
2005/11/16

